﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'P' AND name = 'P_DeletePerson')
	BEGIN
		DROP  Procedure  esf_sso.P_DeletePerson
	END

GO

CREATE Procedure esf_sso.P_DeletePerson
	@pID		BIGINT
AS

	DELETE FROM esf_sso.Person WHERE ID = @pID

GO